HPS MM-EYE
1 Intoduction
Hello, I’m Joseph from Morocco.
Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.
I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.
Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.
This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.
2 About the project
The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.
The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.
3 EDA
3.1 market research indestry’s yearly new recruit count
3.2 hps mm-eye’s workforce status over the years
4 Workforce sample
4.1 Alexandra Szpilska
Job title: Services executive
Associated: False
Socials: https://linkedin.com/in/alexandra-szpilska-8306462b
4.1.1 Alexandra Szpilska’s working period at hps mm-eye
4.1.2 Gantt plot of Alexandra Szpilska’s experience
4.2 Anne Bolingbroke
Job title: Managing director
Associated: True
Socials: https://linkedin.com/in/anne-bolingbroke-935a0a10
4.2.1 Anne Bolingbroke’s working period at hps mm-eye
4.2.2 Gantt plot of Anne Bolingbroke’s experience
4.3 David Chapman
Job title: Research executive trainee
Associated: False
Socials: https://linkedin.com/in/david-chapman | https://linkedin.com/in/david-chapman-795158a7
4.3.1 David Chapman’s working period at hps mm-eye
4.3.2 Gantt plot of David Chapman’s experience
4.4 Deborah Fitzpatrick
Job title: Deputy managing director
Associated: True
Socials: https://linkedin.com/in/deborah-fitzpatrick-70718b33
4.4.1 Deborah Fitzpatrick’s working period at hps mm-eye
4.4.2 Gantt plot of Deborah Fitzpatrick’s experience
4.5 Ina Plewa
Job title: Manager field operations
Associated: False
Socials: https://linkedin.com/in/ina-plewa-42bab966
4.5.1 Ina Plewa’s working period at hps mm-eye
4.5.2 Gantt plot of Ina Plewa’s experience
4.6 Jennifer Mallett
Job title: Research manager
Associated: False
Socials: https://linkedin.com/in/jennifer-mallett-55307222
4.6.1 Jennifer Mallett’s working period at hps mm-eye
4.6.2 Gantt plot of Jennifer Mallett’s experience
4.7 Mandi Kalair
Job title: Office manager and executive assistant to managing director
Associated: False
Socials: https://linkedin.com/in/mandi-kalair-199512b | https://twitter.com/mandikalair
4.7.1 Mandi Kalair’s working period at hps mm-eye
4.7.2 Gantt plot of Mandi Kalair’s experience
4.8 Matthew Crane
Job title: Data consultant
Associated: True
Socials: https://linkedin.com/in/matthew-crane-6b807613
4.8.1 Matthew Crane’s working period at hps mm-eye
4.8.2 Gantt plot of Matthew Crane’s experience
4.9 Meg Rudman-Walsh
Job title: Research director
Associated: True
Socials: https://linkedin.com/in/megrw
4.9.1 Meg Rudman-Walsh’s working period at hps mm-eye
4.9.2 Gantt plot of Meg Rudman-Walsh’s experience
4.10 Michael Bell
Job title: Research analyst
Associated: False
Socials: https://linkedin.com/in/michael-bell-3a32bb99 | https://facebook.com/bellyblah
4.10.1 Michael Bell’s working period at hps mm-eye
4.10.2 Gantt plot of Michael Bell’s experience
4.11 Nicole Müllner
Job title: Assistant to the managing partner, director and to the team
Associated: False
Socials: https://linkedin.com/in/nicole-müllner-3281733
4.11.1 Nicole Müllner’s working period at hps mm-eye
4.11.2 Gantt plot of Nicole Müllner’s experience
4.12 Ole Wassermann
Job title: Research manager
Associated: False
Socials: https://linkedin.com/in/ole-a-wassermann-1328a928
4.12.1 Ole Wassermann’s working period at hps mm-eye
4.12.2 Gantt plot of Ole Wassermann’s experience
4.13 Phil Torode
Job title: Head of data management
Associated: True
Socials: https://linkedin.com/in/phil-torode-65499b4b | https://facebook.com/phil.torode.3
4.13.1 Phil Torode’s working period at hps mm-eye
4.13.2 Gantt plot of Phil Torode’s experience
4.14 Rebecca Wideson
Job title: Senior services executive
Associated: False
Socials: https://linkedin.com/in/rebecca-wideson-bb142a12
4.14.1 Rebecca Wideson’s working period at hps mm-eye
4.14.2 Gantt plot of Rebecca Wideson’s experience
4.15 Sherine Arafa
Job title: Research director
Associated: True
Socials: https://linkedin.com/in/sherine-arafa-47b2b1 | https://linkedin.com/in/sherinearafa
4.15.1 Sherine Arafa’s working period at hps mm-eye
4.15.2 Gantt plot of Sherine Arafa’s experience
4.16 Sue Aitken
Job title: Part time business development consultancy
Associated: False
Socials: https://linkedin.com/in/sueaitkenmarketing